SUBTIPOPATO

"192.168.0.1:sipop"

SUBTIPOPATO

Descriptions

There is no desription for table SUBTIPOPATO

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		ID_SUB_TIPO_PATO		CHAR (2)
		NOMB_SUB_TIPO_PATO		CHAR (30)
		TIPO_PATO		CHAR (2)
		DESC_SUB_TP		CHAR (240)

Triggers

There are no triggers for table SUBTIPOPATO

Indices

There are no indices for table SUBTIPOPATO

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
TIPOPATOLOGIA	INTEG_291	TIPO_PATO	ID_TIPO_PATOLOGIA	RESTRICT	RESTRICT

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PATOLOGIA	INTEG_272	SUB_TIPO_PATO	ID_SUB_TIPO_PATO	RESTRICT	RESTRICT

Definition


CREATE TABLE SUBTIPOPATO (
    ID_SUB_TIPO_PATO CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMB_SUB_TIPO_PATO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    TIPO_PATO CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESC_SUB_TP CHAR (240) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE SUBTIPOPATO ADD PRIMARY KEY (ID_SUB_TIPO_PATO);
ALTER TABLE SUBTIPOPATO ADD  FOREIGN KEY (TIPO_PATO) REFERENCES TIPOPATOLOGIA (ID_TIPO_PATOLOGIA);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 04:58 p.m.